School of Computer EngineeringcorelabSem 5
DATABASE SYSTEMS LAB
CSS 2212
Syllabus
- 01Data Definition Language
- 02Data manipulation language
- 03Basic database query operations
- 04Integrity Constraints in SQL
- 05Nested subqueries
- 06Join Operations
- 07Views
- 08PL/SQL Basics
- 09Exception Handling
- 10Cursors
- 11Stored procedures
- 12Functions
- 13Packages
- 14Trigger
- 15project on design and development of application based on database concepts
References
- Silberschatz, Korth, Sudarshan, Database System Concepts, (7e)McGrawHill, 2011
- Ivan Bayross, SQL, PL/SQL, (3e), BPB Publications
- Satish Asnani, Oracle Database 11g, PHI, 2010
- Scott Urman, ORACLE – PL/SQL Programming, Oracle Press
Credits Structure
0Lecture
0Tutorial
3Practical
1Total